{"text_format":"1","workbook":"xlsx","n_sheets":5,"sheets":["Home page","Car transport","Public transport","Active transport","Ciry Bike Finland - data"],"not_rendered":{"charts":2,"images":31,"macros":1,"external_links":0,"defined_names":192,"comments":3,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Home page","index":0,"n_rows":30,"n_cols":4,"rows_kept":30,"cut":false,"hidden":false,"merged":[]}
["Alternative mobility calculator KULKURI"]
["Version 1.1"]
["Welcome to KULKURI, the Alternative mobility calculator. The calculator is inteded to be used to calculate annual costs and annual lifecycle greenhouse gas (GHG) emissions of different mobility solutions other than car ownership."]
["The calculator has been developed in the course of the CANEMURE LIFE IP project."]
[]
["Note: In case the calculator does not work when downloaded from the web, try to copy it from your Downloads folder to another destination in your computer."]
[]
["Developer:","Jáchym Judl","jachym.judl@syke.fi"]
["Last update:","1900-01-15"]
[]
["Define your mobility needs in the sheets \"Car transport\", \"Public transport\" and \"Active transport\". By clicking on the hyperlinks below you will be directed there where input is needed."]
["Cells highlighted like this require input. Fill in own parameter values or choose an option from a drop-down list."]
["Cells highlighted like this contain default parameters. They can be modified by the user, if needed."]
[]
["Form of transport","Costs per year","Emissions per year"]
["Car rental",{"$f":"'Car transport'!C4","v":0},{"$f":"'Car transport'!C5","v":0},"kg CO2e"]
["Car rental (peer-to-peer)",{"$f":"'Car transport'!#REF!","v":{"$error":"#REF!"}},{"$f":"'Car transport'!#REF!","v":{"$error":"#REF!"}},"kg CO2e"]
["Car sharing",{"$f":"'Car transport'!Q4","v":0},{"$f":"'Car transport'!Q5","v":0},"kg CO2e"]
["Taxi",{"$f":"'Car transport'!Z4","v":0},{"$f":"'Car transport'!Z5","v":0},"kg CO2e"]
["City public transport",{"$f":"'Public transport'!C4","v":0},{"$f":"'Public transport'!C5","v":0},"kg CO2e"]
["Long-distance public transport",{"$f":"'Public transport'!C9","v":0},{"$f":"'Public transport'!C10","v":0},"kg CO2e"]
["Bicycle",{"$f":"'Active transport'!B10+'Active transport'!B32","v":0},{"$f":"'Active transport'!B11+'Active transport'!B33","v":0},"kg CO2e"]
["Electric bicycle",{"$f":"'Active transport'!F10*'Active transport'!F3","v":0},{"$f":"'Active transport'!F11*'Active transport'!F3","v":0},"kg CO2e"]
["(Electric) cargo bike",{"$f":"'Active transport'!J10","v":0},{"$f":"'Active transport'!J11","v":0},"kg CO2e"]
["Bike sharing",{"$f":"'Active transport'!O6","v":0},{"$f":"'Active transport'!O8","v":0},"kg CO2e"]
[null,{"$f":"SUMIF(B16:B25,\">0\")","v":0},{"$f":"ROUND(SUMIF(C16:C25,\">0\"),0)&\" kg CO2e\"","v":"0 kg CO2e"}]
["Distance driven in total:",null,null,{"$f":"('Car transport'!C3+'Car transport'!Q3+'Car transport'!Z3)& \" km\"","v":"0 km"}]
["Distance travelled by city public transport:",null,null,{"$f":"('Public transport'!$C$3)& \" km\"","v":"0 km"}]
["Distance travelled by long-distance public transport:",null,null,{"$f":"('Public transport'!$C$8)& \" km\"","v":"0 km"}]
["Distance travelled by bike:",null,null,{"$f":"ROUND(('Active transport'!$B$8+'Active transport'!$B$30+'Active transport'!$F$8+'Active transport'!$J$8+'Active transport'!$O$5),0)& \" km\"","v":"0 km"}]

{"sheet":"Car transport","index":1,"n_rows":65,"n_cols":32,"rows_kept":65,"cut":false,"hidden":false,"merged":[]}
["Car rental",null,null,null,null,null,null,null,"select",null,null,null,null,null,"Car sharing",null,null,null,null,null,null,null,null,"Taxi",null,null,null,null,null,null,null,"Van rental (possibly to be added)"]
["Summary:",null,null,null,null,null,"Rental costs",null,"Day rental",50,"€/day",null,null,null,"Summary:",null,null,null,null,null,null,null,null,"Summary:"]
["Total distance driven in rental car, per year",null,{"$f":"SUMPRODUCT(D9:D28,B9:B28)","v":0},"km",null,null,null,null,"Weekend rental",100,"€/weekend",null,null,null,"Total distance driven in a shared car, per year",null,{"$f":"SUMPRODUCT(O9:O28,P9:P28)","v":0},"km",null,null,null,null,null,"Total distance driven in a taxi, per year",null,{"$f":"SUMPRODUCT(X9:X28,Y9:Y28)","v":0},"km"]
["Total cost of renting, per year",null,{"$f":"SUM(J9:J28)","v":0},"€",null,null,null,null,"Week rental",350,"€/week",null,null,null,"Total cost of sharing, per year",null,{"$f":"SUM(U9:U28)","v":0},"€",null,null,null,null,null,"Total cost of taxi use, per year",null,{"$f":"SUM(AC9:AC28)","v":0},"€"]
["Total emissions, per year",null,{"$f":"SUM(K9:K28)","v":0},"kg CO2e",null,null,null,null,null,null,null,null,null,null,"Total emissions, per year",null,{"$f":"SUM(V9:V28)","v":0},"kg CO2e",null,null,null,null,null,"Total emissions, per year",null,{"$f":"SUM(AD9:AD28)","v":0},"kg CO2e"]
[]
[]
["Length of rental","Distance driven, per rental [km]","Cost of rental [€/rental]","Number of similar trips, per year","Fuel type","Number of additional drivers","CDW","Other extras, per rental",null,"Total cost [€]","Emissions [kg CO2e]",null,"cost of rental [€/rental] - default equation",null,"Number of similar rentals, per year","Distance driven, per rental [km]","Duration, per rental [min]","Type of sharing service","Fuel type","Cost per rental [€]","Total cost [€]","Emissions [kg CO2e]",null,"Number of similar taxi rides, per year","Distance driven, per taxi ride [km]","day/night/weekend","Fuel type","Cost of the taxi ride","Total costs [€]","Emissions [kg CO2e]"]
["select",null,{"$f":"IF(A9=TEXT($I$2,),$J$2,IF(A9=TEXT($I$3,),$J$3,IF(A9=TEXT($I$4,),$J$4,)))","v":0},1,"petrol",0,null,null,null,{"$f":"IF(A9=TEXT($I$2,),(D9*(C9+F9*$C$31+IF(G9=\"YES\",$C$32,0)+H9)),IF(A9=TEXT($I$3,),(D9*(C9+F9*$C$31*3+IF(G9=\"YES\",$C$32,0)*3+H9)),IF(A9=TEXT($I$4,),(D9*(C9+F9*$C$31*7+IF(G9=\"YES\",$C$32,0)*7+H9)))))+IF(E9=TEXT($B$65,),($C$35*$C$40*B9)*D9,IF(E9=TEXT($C$65,),($C$36*$C$41*B9)*D9,IF(E9=TEXT($D$65,),($C$37*$C$42*B9)*D9,0)))","v":0},{"$f":"IF(E9=TEXT($B$65,),(($D$55+$D$56)*$C$35*B9+$D$57*B9)*D9,IF(E9=TEXT($C$65,),(($D$58+$D$59)*$C$36*B9+$D$60*B9)*D9,IF(E9=TEXT($D$65,),(($D$61+$D$62)*$C$37*B9+$D$63*B9)*D9,0)))","v":0},null,{"$f":"IF(A9=TEXT($I$2,),$J$2,IF(A9=TEXT($I$3,),$J$3,IF(A9=TEXT($I$4,),$J$4,)))","v":0},null,null,null,null,"Service A","petrol",{"$f":"IF(R9=TEXT($R$31,),($R$32+P9*$R$33+Q9*$R$34),IF(R9=TEXT($S$31,),($S$32+P9*$S$33+Q9*$S$34),IF(R9=TEXT($T$31,),($T$32+P9*$T$33+Q9*$T$34))))","v":0},{"$f":"T9*O9","v":0},{"$f":"IF(S9=TEXT($B$65,),(($D$55+$D$56)*$Q$39*P9+$D$57*P9)*O9,IF(S9=TEXT($C$65,),(($D$58+$D$59)*$Q$40*P9+$D$60*P9)*O9,IF(S9=TEXT($D$65,),(($D$61+$D$62)*$Q$41*P9+$D$63*P9)*O9,0)))","v":0},null,null,null,"weekend","diesel",{"$f":"IF(Z9=TEXT($AA$31,),($AA$32+$AA$33*Y9),(IF(Z9=TEXT($AB$31,),($AB$32+Y9*$AB$33),(IF(Z9=TEXT($AC$31,),($AC$32+Y9*$AC$33),0)))))*IF(X9>0,1,0)","v":0},{"$f":"X9*AB9","v":0},{"$f":"IF(AA9=$B$65,($D$55+$D$56)*$Z$39*Y9*X9+$D$57*Y9*X9,IF(AA9=$C$65,($D$58+$D$59)*$Z$40*Y9*X9+$D$60*Y9*X9,IF(AA9=$D$65,($D$61+$D$62)*$Z$41*Y9*X9+$D$63*Y9*X9,0)))","v":0}]
["select",null,{"$f":"IF(A10=TEXT($I$2,),$J$2,IF(A10=TEXT($I$3,),$J$3,IF(A10=TEXT($I$4,),$J$4,)))","v":0},1,"petrol",0,null,null,null,0,{"$f":"IF(E10=TEXT($B$65,),(($D$55+$D$56)*$C$35*B10+$D$57*B10)*D10,IF(E10=TEXT($C$65,),(($D$58+$D$59)*$C$35*B10+$D$60*B10)*D10,IF(E10=TEXT($D$65,),(($D$61+$D$62)*$C$35*B10+$D$63*B10)*D10,0)))","v":0},null,{"$f":"IF(A10=TEXT($I$2,),$J$2,IF(A10=TEXT($I$3,),$J$3,IF(A10=TEXT($I$4,),$J$4,)))","v":0},null,null,null,null,"Service A","petrol",0,{"$f":"T10*O10","v":0},0,null,null,null,"weekend","diesel",0,0,{"$f":"IF(AA10=$B$65,($D$55+$D$56)*$Z$39*Y10*X10+$D$57*Y10*X10,IF(AA10=$C$65,($D$58+$D$59)*$Z$40*Y10*X10+$D$60*Y10*X10,IF(AA10=$D$65,($D$61+$D$62)*$Z$41*Y10*X10+$D$63*Y10*X10,0)))","v":0}]
["select",null,{"$f":"IF(A11=TEXT($I$2,),$J$2,IF(A11=TEXT($I$3,),$J$3,IF(A11=TEXT($I$4,),$J$4,)))","v":0},1,"petrol",0,null,null,null,0,0,null,0,null,null,null,null,"Service A","petrol",0,0,0,null,null,null,"weekend","diesel",0,0,{"$f":"IF(AA11=$B$65,($D$55+$D$56)*$Z$39*Y11*X11+$D$57*Y11*X11,IF(AA11=$C$65,($D$58+$D$59)*$Z$40*Y11*X11+$D$60*Y11*X11,IF(AA11=$D$65,($D$61+$D$62)*$Z$41*Y11*X11+$D$63*Y11*X11,0)))","v":0}]
["select",null,{"$f":"IF(A12=TEXT($I$2,),$J$2,IF(A12=TEXT($I$3,),$J$3,IF(A12=TEXT($I$4,),$J$4,)))","v":0},1,"petrol",0,null,null,null,0,0,null,0,null,null,null,null,"Service A","petrol",0,0,0,null,null,null,"weekend","diesel",0,0,0]
["select",null,{"$f":"IF(A13=TEXT($I$2,),$J$2,IF(A13=TEXT($I$3,),$J$3,IF(A13=TEXT($I$4,),$J$4,)))","v":0},1,"petrol",0,null,null,null,0,0,null,0,null,null,null,null,"Service A","petrol",0,0,0,null,null,null,"weekend","diesel",0,0,0]
["select",null,{"$f":"IF(A14=TEXT($I$2,),$J$2,IF(A14=TEXT($I$3,),$J$3,IF(A14=TEXT($I$4,),$J$4,)))","v":0},1,"petrol",0,null,null,null,0,0,null,0,null,null,null,null,"Service A","petrol",0,0,0,null,null,null,"weekend","diesel",0,0,0]
["select",null,{"$f":"IF(A15=TEXT($I$2,),$J$2,IF(A15=TEXT($I$3,),$J$3,IF(A15=TEXT($I$4,),$J$4,)))","v":0},1,"petrol",0,null,null,null,0,0,null,0,null,null,null,null,"Service A","petrol",0,0,0,null,null,null,"weekend","diesel",0,0,0]
["select",null,{"$f":"IF(A16=TEXT($I$2,),$J$2,IF(A16=TEXT($I$3,),$J$3,IF(A16=TEXT($I$4,),$J$4,)))","v":0},1,"petrol",0,null,null,null,0,0,null,{"$f":"IF(A16=TEXT($I$2,),$J$2,IF(A16=TEXT($I$3,),$J$3,IF(A16=TEXT($I$4,),$J$4,)))","v":0},null,null,null,null,"Service A","petrol",0,0,0,null,null,null,"weekend","diesel",0,0,0]
["select",null,{"$f":"IF(A17=TEXT($I$2,),$J$2,IF(A17=TEXT($I$3,),$J$3,IF(A17=TEXT($I$4,),$J$4,)))","v":0},1,"petrol",0,null,null,null,0,0,null,0,null,null,null,null,"Service A","petrol",0,0,0,null,null,null,"weekend","diesel",0,0,0]
["select",null,{"$f":"IF(A18=TEXT($I$2,),$J$2,IF(A18=TEXT($I$3,),$J$3,IF(A18=TEXT($I$4,),$J$4,)))","v":0},1,"petrol",0,null,null,null,0,0,null,0,null,null,null,null,"Service A","petrol",0,0,0,null,null,null,"weekend","diesel",0,0,0]
["select",null,{"$f":"IF(A19=TEXT($I$2,),$J$2,IF(A19=TEXT($I$3,),$J$3,IF(A19=TEXT($I$4,),$J$4,)))","v":0},1,"petrol",0,null,null,null,0,0,null,0,null,null,null,null,"Service A","petrol",0,0,0,null,null,null,"weekend","diesel",0,0,0]
["select",null,{"$f":"IF(A20=TEXT($I$2,),$J$2,IF(A20=TEXT($I$3,),$J$3,IF(A20=TEXT($I$4,),$J$4,)))","v":0},1,"petrol",0,null,null,null,0,0,null,0,null,null,null,null,"Service A","petrol",0,0,0,null,null,null,"weekend","diesel",0,0,0]
["select",null,{"$f":"IF(A21=TEXT($I$2,),$J$2,IF(A21=TEXT($I$3,),$J$3,IF(A21=TEXT($I$4,),$J$4,)))","v":0},1,"petrol",0,null,null,null,0,0,null,0,null,null,null,null,"Service A","petrol",0,0,0,null,null,null,"weekend","diesel",0,0,0]
["select",null,{"$f":"IF(A22=TEXT($I$2,),$J$2,IF(A22=TEXT($I$3,),$J$3,IF(A22=TEXT($I$4,),$J$4,)))","v":0},1,"petrol",0,null,null,null,0,0,null,0,null,null,null,null,"Service A","petrol",0,0,0,null,null,null,"weekend","diesel",0,0,0]
["select",null,{"$f":"IF(A23=TEXT($I$2,),$J$2,IF(A23=TEXT($I$3,),$J$3,IF(A23=TEXT($I$4,),$J$4,)))","v":0},1,"petrol",0,null,null,null,0,0,null,0,null,null,null,null,"Service A","petrol",0,0,0,null,null,null,"weekend","diesel",0,0,0]
["select",null,{"$f":"IF(A24=TEXT($I$2,),$J$2,IF(A24=TEXT($I$3,),$J$3,IF(A24=TEXT($I$4,),$J$4,)))","v":0},1,"petrol",0,null,null,null,0,0,null,0,null,null,null,null,"Service A","petrol",0,0,0,null,null,null,"weekend","diesel",0,0,0]
["select",null,{"$f":"IF(A25=TEXT($I$2,),$J$2,IF(A25=TEXT($I$3,),$J$3,IF(A25=TEXT($I$4,),$J$4,)))","v":0},1,"petrol",0,null,null,null,0,0,null,0,null,null,null,null,"Service A","petrol",0,0,0,null,null,null,"weekend","diesel",0,0,0]
["select",null,{"$f":"IF(A26=TEXT($I$2,),$J$2,IF(A26=TEXT($I$3,),$J$3,IF(A26=TEXT($I$4,),$J$4,)))","v":0},1,"petrol",0,null,null,null,0,0,null,0,null,null,null,null,"Service A","petrol",0,0,0,null,null,null,"weekend","diesel",0,0,0]
["select",null,{"$f":"IF(A27=TEXT($I$2,),$J$2,IF(A27=TEXT($I$3,),$J$3,IF(A27=TEXT($I$4,),$J$4,)))","v":0},1,"petrol",0,null,null,null,0,0,null,0,null,null,null,null,"Service A","petrol",0,0,0,null,null,null,"weekend","diesel",0,0,0]
["select",null,{"$f":"IF(A28=TEXT($I$2,),$J$2,IF(A28=TEXT($I$3,),$J$3,IF(A28=TEXT($I$4,),$J$4,)))","v":0},1,"petrol",0,null,null,null,0,0,null,0,null,null,null,null,"Service A","petrol",0,0,0,null,null,null,"weekend","diesel",0,0,0]
[]
["Optional rental costs"]
["Additional driver","€/day",10,null,null,null,null,null,null,null,null,null,null,null,null,null,"select","Service A","Service B","Service C",null,null,null,null,null,null,"day","night","weekend"]
["CDW waiver","€/day",15,null,null,null,null,null,null,null,null,null,null,null,"Starting fee",null,"€",0,0,"currently not implemented",null,null,null,"Starting fee",null,"€",4,7,7]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Price, per km",null,"€/km",0,0.15,null,null,null,null,"Price, per km",null,"€/km",1,1.1000000000000001,1.1000000000000001]
["Car parameters",null,null,null,null,null,null,null,null,null,null,null,null,null,"Price, per minute",null,"€/min",0.47,0.2,null,null,null,null,"Price, per minute",null,"€/min","currently not implemented"]
["Fuel consumption (petrol)","l/km",5.5E-2]
["Fuel consumption (diesel)","l/km",5.5E-2]
["Electricity consumption","kWh/km",1.7000000000000001E-2]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Car parameters",null,null,null,null,null,null,null,null,"Car parameters"]
["Fuel cost",null,null,null,null,null,null,null,null,null,null,null,null,null,"Fuel consumption (petrol)","l/km",5.5E-2,null,null,null,null,null,null,"Fuel consumption (petrol)","l/km",5.5E-2]
["Petrol","€/l",1.45,null,null,null,null,null,null,null,null,null,null,null,"Fuel consumption (diesel)","l/km",5.5E-2,null,null,null,null,null,null,"Fuel consumption (diesel)","l/km",5.5E-2]
["Diesel","€/l",1.25,null,null,null,null,null,null,null,null,null,null,null,"Electricity consumption","kWh/km",0.17,null,null,null,null,null,null,"Electricity consumption","kWh/km",0.17]
["Electricity","€/kWh",0.22]
[]
["Lifespan mileage"]
["Petrol / diesel car, medium size","km",300000]
["Electric car, medium size (40 kWh battery)","km",200000]
[]
[]
["Emission factors (Source: Autokalkulaattori.fi) ↓"]
["car manufacturing (Source: Autokalkulaattori.fi)"]
["Petrol / diesel car, medium size","t CO2e",5.36]
["Electric car, medium size (40 kWh battery)","t CO2e",{"$f":"6.52+40*0.1","v":10.52}]
[]
["Emission factors (Source: Autokalkulaattori.fi)"]
["Petrol","direct emissions","kg CO2-ekv/l",2.3479999999999999]
[null,"fuel production emissions","kg CO2-ekv/l",0.65500000000000003]
[null,"car production emissions","kg CO2-ekv/km",{"$f":"C51*1000/C45","v":1.7866666666666666E-2}]
["Diesel","direct emissions","kg CO2-ekv/l",2.6890000000000001]
[null,"production emissions","kg CO2-ekv/l",0.75]
[null,"car production emissions","kg CO2-ekv/km",{"$f":"C51*1000/C45","v":1.7866666666666666E-2}]
["Electric","direct emissions","kg CO2-ekv/kWh",9.6000000000000002E-2]
[null,"production emissions","kg CO2-ekv/kWh",1.6E-2]
[null,"car production emissions","kg CO2-ekv/km",{"$f":"C52*1000/C46","v":5.2600000000000001E-2}]
[]
["Fuel type","petrol","diesel","electric"]

{"sheet":"Public transport","index":2,"n_rows":44,"n_cols":13,"rows_kept":44,"cut":false,"hidden":false,"merged":[[38,2,39,3],[40,2,43,8]]}
["Public transport"]
["Summary (city public transport):",null,null,null,null,null,null,"Number of months with a valid city public transport period ticket, per household, per year"]
["Total distance travelled in city public transport, per year",null,{"$f":"SUM(F15:F34)","v":0},"km",null,null,null,"adults",null,0]
["Total cost of city public transport, per year",null,{"$f":"SUMIF(B15:B34,TEXT(A39,),I15:I34)+SUMIF(B15:B34,TEXT(A41,),I15:I34)+SUMIF(B15:B34,TEXT(A43,),I15:I34)+SUMIF(B15:B34,TEXT(A44,),I15:I34)+J8*J3+J9*J4","v":0},"€",null,null,null,"children",null,0]
["Total emissions, per year",null,{"$f":"SUMIF(B15:B34,TEXT(A39,),J15:J34)+SUMIF(B15:B34,TEXT(A41,),J15:J34)+SUMIF(B15:B34,TEXT(A43,),J15:J34)+SUMIF(B15:B34,TEXT(A44,),J15:J34)","v":0},"kg CO2e"]
[null,null,null,null,null,null,null,"Cost of public transport tickets (period ticket and different single tickets)"]
["Summary (long-distance transport):",null,null,null,null,null,null,"Ticket type"]
["Total distance travelled in long-distance public transport, per year",null,{"$f":"SUM(G15:G34)","v":0},"km",null,null,null,"Period ticket (adult)","€/month",55]
["Total cost of long-distance public transport, per year",null,{"$f":"SUMIF(B15:B34,TEXT(A40,),I15:I34)+SUMIF(B15:B34,TEXT(A42,),I15:I34)","v":0},"€",null,null,null,"Period ticket (child)","€/month",27.4]
["Total emissions, per year",null,{"$f":"SUMIF(B15:B34,TEXT(A40,),J15:J34)+SUMIF(B15:B34,TEXT(A42,),J15:J34)","v":0},"kg CO2e",null,null,null,"Single ticket A","€/ticket",3]
[null,null,null,null,null,null,null,"Single ticket B","€/ticket",4]
[null,null,null,null,null,null,null,"Single ticket C","€/ticket",6]
[]
["Number of simiar trips, per year","Mean of transport","Distance per trip [km]","Ticket type","Long distance transport ticket price","city public transport distance, per defined number of trips [km]","long-distance public transport distance, per defined number of trips [km]","Cost of the trip (if paid per trip) [€]","Total cost (if paid per trip) [€]","Emissions [kg CO2e]",null,"distance per trip","long distance transport ticket price"]
[null,"select",{"$f":"IF(B15=TEXT($A$39,),10,IF(B15=TEXT($A$43,),5,IF(B15=TEXT($A$44,),10,IF(B15=TEXT($A$41,),15,IF(B15=TEXT($A$40,),150,IF(B15=TEXT($A$42,),300,))))))","v":0},"select",{"$f":"IF(B15=TEXT($A$40,),20,IF(B15=TEXT($A$42,),40,0))","v":0},{"$f":"IF(B15=TEXT($A$39,),A15*C15,IF(B15=TEXT($A$43,),A15*C15,IF(B15=TEXT($A$44,),A15*C15,IF(B15=TEXT($A$41,),A15*C15))))","v":false},{"$f":"IF(B15=TEXT($A$40,),A15*C15,IF(B15=TEXT($A$42,),A15*C15))","v":false},{"$f":"IF(D15=TEXT($H$8,),0,IF(D15=TEXT($H$10,),$J$10,(IF(D15=TEXT($H$11,),$J$11,(IF(D15=TEXT($H$12,),$J$12,0))))))+E15","v":0},{"$f":"A15*H15","v":0},{"$f":"(IF(B15=TEXT($A$39,),$B$39,IF(B15=TEXT($A$40,),$B$40,IF(B15=TEXT($A$41,),$B$41,IF(B15=TEXT($A$42,),$B$42,IF(B15=TEXT($A$43,),$B$43,IF(B15=TEXT($A$44,),$B$44,0)))))))/1000*C15*A15","v":0},null,{"$f":"IF(B15=TEXT($A$39,),10,IF(B15=TEXT($A$43,),5,IF(B15=TEXT($A$44,),10,IF(B15=TEXT($A$41,),15,IF(B15=TEXT($A$40,),150,IF(B15=TEXT($A$42,),300,))))))","v":0},{"$f":"IF(B15=TEXT($A$40,),20,IF(B15=TEXT($A$42,),40,0))","v":0}]
[null,"select",{"$f":"IF(B16=TEXT($A$39,),10,IF(B16=TEXT($A$43,),5,IF(B16=TEXT($A$44,),10,IF(B16=TEXT($A$41,),15,IF(B16=TEXT($A$40,),150,IF(B16=TEXT($A$42,),300,))))))","v":0},"select",{"$f":"IF(B16=TEXT($A$40,),20,IF(B16=TEXT($A$42,),40,0))","v":0},{"$f":"IF(B16=TEXT($A$39,),A16*C16,IF(B16=TEXT($A$43,),A16*C16,IF(B16=TEXT($A$44,),A16*C16,IF(B16=TEXT($A$41,),A16*C16))))","v":false},{"$f":"IF(B16=TEXT($A$40,),A16*C16,IF(B16=TEXT($A$42,),A16*C16))","v":false},0,{"$f":"A16*H16","v":0},0,null,{"$f":"IF(B16=TEXT($A$39,),10,IF(B16=TEXT($A$43,),5,IF(B16=TEXT($A$44,),10,IF(B16=TEXT($A$41,),15,IF(B16=TEXT($A$40,),150,IF(B16=TEXT($A$42,),300,))))))","v":0},{"$f":"IF(B16=TEXT($A$40,),20,IF(B16=TEXT($A$42,),40,0))","v":0}]
[null,"select",{"$f":"IF(B17=TEXT($A$39,),10,IF(B17=TEXT($A$43,),5,IF(B17=TEXT($A$44,),10,IF(B17=TEXT($A$41,),15,IF(B17=TEXT($A$40,),150,IF(B17=TEXT($A$42,),300,))))))","v":0},"select",{"$f":"IF(B17=TEXT($A$40,),20,IF(B17=TEXT($A$42,),40,0))","v":0},false,false,0,0,0,null,0,0]
[null,"select",{"$f":"IF(B18=TEXT($A$39,),10,IF(B18=TEXT($A$43,),5,IF(B18=TEXT($A$44,),10,IF(B18=TEXT($A$41,),15,IF(B18=TEXT($A$40,),150,IF(B18=TEXT($A$42,),300,))))))","v":0},"select",{"$f":"IF(B18=TEXT($A$40,),20,IF(B18=TEXT($A$42,),40,0))","v":0},false,false,0,0,0,null,0,0]
[null,"select",{"$f":"IF(B19=TEXT($A$39,),10,IF(B19=TEXT($A$43,),5,IF(B19=TEXT($A$44,),10,IF(B19=TEXT($A$41,),15,IF(B19=TEXT($A$40,),150,IF(B19=TEXT($A$42,),300,))))))","v":0},"select",{"$f":"IF(B19=TEXT($A$40,),20,IF(B19=TEXT($A$42,),40,0))","v":0},false,false,0,0,0,null,0,0]
[null,"select",{"$f":"IF(B20=TEXT($A$39,),10,IF(B20=TEXT($A$43,),5,IF(B20=TEXT($A$44,),10,IF(B20=TEXT($A$41,),15,IF(B20=TEXT($A$40,),150,IF(B20=TEXT($A$42,),300,))))))","v":0},"select",{"$f":"IF(B20=TEXT($A$40,),20,IF(B20=TEXT($A$42,),40,0))","v":0},false,false,0,0,0,null,0,0]
[null,"select",{"$f":"IF(B21=TEXT($A$39,),10,IF(B21=TEXT($A$43,),5,IF(B21=TEXT($A$44,),10,IF(B21=TEXT($A$41,),15,IF(B21=TEXT($A$40,),150,IF(B21=TEXT($A$42,),300,))))))","v":0},"select",{"$f":"IF(B21=TEXT($A$40,),20,IF(B21=TEXT($A$42,),40,0))","v":0},false,false,0,0,0,null,0,0]
[null,"select",{"$f":"IF(B22=TEXT($A$39,),10,IF(B22=TEXT($A$43,),5,IF(B22=TEXT($A$44,),10,IF(B22=TEXT($A$41,),15,IF(B22=TEXT($A$40,),150,IF(B22=TEXT($A$42,),300,))))))","v":0},"select",{"$f":"IF(B22=TEXT($A$40,),20,IF(B22=TEXT($A$42,),40,0))","v":0},false,false,0,0,0,null,0,0]
[null,"select",{"$f":"IF(B23=TEXT($A$39,),10,IF(B23=TEXT($A$43,),5,IF(B23=TEXT($A$44,),10,IF(B23=TEXT($A$41,),15,IF(B23=TEXT($A$40,),150,IF(B23=TEXT($A$42,),300,))))))","v":0},"select",{"$f":"IF(B23=TEXT($A$40,),20,IF(B23=TEXT($A$42,),40,0))","v":0},false,false,0,0,0,null,0,0]
[null,"select",{"$f":"IF(B24=TEXT($A$39,),10,IF(B24=TEXT($A$43,),5,IF(B24=TEXT($A$44,),10,IF(B24=TEXT($A$41,),15,IF(B24=TEXT($A$40,),150,IF(B24=TEXT($A$42,),300,))))))","v":0},"select",{"$f":"IF(B24=TEXT($A$40,),20,IF(B24=TEXT($A$42,),40,0))","v":0},false,false,0,0,0,null,0,0]
[null,"select",{"$f":"IF(B25=TEXT($A$39,),10,IF(B25=TEXT($A$43,),5,IF(B25=TEXT($A$44,),10,IF(B25=TEXT($A$41,),15,IF(B25=TEXT($A$40,),150,IF(B25=TEXT($A$42,),300,))))))","v":0},"select",{"$f":"IF(B25=TEXT($A$40,),20,IF(B25=TEXT($A$42,),40,0))","v":0},false,false,0,0,0,null,0,0]
[null,"select",{"$f":"IF(B26=TEXT($A$39,),10,IF(B26=TEXT($A$43,),5,IF(B26=TEXT($A$44,),10,IF(B26=TEXT($A$41,),15,IF(B26=TEXT($A$40,),150,IF(B26=TEXT($A$42,),300,))))))","v":0},"select",{"$f":"IF(B26=TEXT($A$40,),20,IF(B26=TEXT($A$42,),40,0))","v":0},false,false,0,0,0,null,0,0]
[null,"select",{"$f":"IF(B27=TEXT($A$39,),10,IF(B27=TEXT($A$43,),5,IF(B27=TEXT($A$44,),10,IF(B27=TEXT($A$41,),15,IF(B27=TEXT($A$40,),150,IF(B27=TEXT($A$42,),300,))))))","v":0},"select",{"$f":"IF(B27=TEXT($A$40,),20,IF(B27=TEXT($A$42,),40,0))","v":0},false,false,0,0,0,null,0,0]
[null,"select",{"$f":"IF(B28=TEXT($A$39,),10,IF(B28=TEXT($A$43,),5,IF(B28=TEXT($A$44,),10,IF(B28=TEXT($A$41,),15,IF(B28=TEXT($A$40,),150,IF(B28=TEXT($A$42,),300,))))))","v":0},"select",{"$f":"IF(B28=TEXT($A$40,),20,IF(B28=TEXT($A$42,),40,0))","v":0},false,false,0,0,0,null,0,0]
[null,"select",{"$f":"IF(B29=TEXT($A$39,),10,IF(B29=TEXT($A$43,),5,IF(B29=TEXT($A$44,),10,IF(B29=TEXT($A$41,),15,IF(B29=TEXT($A$40,),150,IF(B29=TEXT($A$42,),300,))))))","v":0},"select",{"$f":"IF(B29=TEXT($A$40,),20,IF(B29=TEXT($A$42,),40,0))","v":0},false,false,0,0,0,null,0,0]
[null,"select",{"$f":"IF(B30=TEXT($A$39,),10,IF(B30=TEXT($A$43,),5,IF(B30=TEXT($A$44,),10,IF(B30=TEXT($A$41,),15,IF(B30=TEXT($A$40,),150,IF(B30=TEXT($A$42,),300,))))))","v":0},"select",{"$f":"IF(B30=TEXT($A$40,),20,IF(B30=TEXT($A$42,),40,0))","v":0},false,false,0,0,0,null,0,0]
[null,"select",{"$f":"IF(B31=TEXT($A$39,),10,IF(B31=TEXT($A$43,),5,IF(B31=TEXT($A$44,),10,IF(B31=TEXT($A$41,),15,IF(B31=TEXT($A$40,),150,IF(B31=TEXT($A$42,),300,))))))","v":0},"select",{"$f":"IF(B31=TEXT($A$40,),20,IF(B31=TEXT($A$42,),40,0))","v":0},false,false,0,0,0,null,0,0]
[null,"select",{"$f":"IF(B32=TEXT($A$39,),10,IF(B32=TEXT($A$43,),5,IF(B32=TEXT($A$44,),10,IF(B32=TEXT($A$41,),15,IF(B32=TEXT($A$40,),150,IF(B32=TEXT($A$42,),300,))))))","v":0},"select",{"$f":"IF(B32=TEXT($A$40,),20,IF(B32=TEXT($A$42,),40,0))","v":0},false,false,0,0,0,null,0,0]
[null,"select",{"$f":"IF(B33=TEXT($A$39,),10,IF(B33=TEXT($A$43,),5,IF(B33=TEXT($A$44,),10,IF(B33=TEXT($A$41,),15,IF(B33=TEXT($A$40,),150,IF(B33=TEXT($A$42,),300,))))))","v":0},"select",{"$f":"IF(B33=TEXT($A$40,),20,IF(B33=TEXT($A$42,),40,0))","v":0},false,false,0,0,0,null,0,0]
[null,"select",{"$f":"IF(B34=TEXT($A$39,),10,IF(B34=TEXT($A$43,),5,IF(B34=TEXT($A$44,),10,IF(B34=TEXT($A$41,),15,IF(B34=TEXT($A$40,),150,IF(B34=TEXT($A$42,),300,))))))","v":0},"select",{"$f":"IF(B34=TEXT($A$40,),20,IF(B34=TEXT($A$42,),40,0))","v":0},false,false,0,0,0,null,0,0]
[]
["Hidden rows below contain emission factors from Ilmastodieetti.fi ↓"]
["Source: VTT’s LIPASTO database (data from 2016), complemented with estimated emissions from the fuel supply chain (diesel approximately 20%) and fleet production (approximately 1 g per passenger km). (as done in Ilmastodieetti)",null,null,null,null,null,null,null,"http://lipasto.vtt.fi/yksikkopaastot/henkiloliikenne/tieliikenne/linja-autot/bussilinjaautokeskimaarin.htm"]
["select","g CO2eq/passenger km"]
["bus, local",{"$f":"53*1.2+1","v":64.599999999999994},"Note: Lipasto gives 41 g CO2eq/hkm pitkän matkan bussille and 53 g CO2eq/hkm kaupunkibussille (average in 2016)."]
["bus, long-distance",{"$f":"41*1.2+1","v":50.199999999999996}]
["train, local",1,"VR and HKL use green electricity, and the calculated emissions factor of green electricity is 0 g CO2eq/kWh. The figure 1 g CO2eq/kWh is derived from the estimated emissions from fleet production.  (as done in Ilmastodieetti)\n\nAccording to Lipast (2016) Intercity train's energy consumption is 0,054 kWh/pkm and 0,071 kWh/pkm per Sm5 (FLIRT) commuter train. Multiplying these values with the emission factor of electricity production leads to far lower numbers than the used 1 g CO2e. 6,048 g/pkm for the intercity train and 7,952 g/pkm for the commuter train.\n\nFor metro the Lipasto reported consumption is 0,18 kWh/pkm (20,16 g CO2e/pkm if average grid mix is considered).\n\nFor metro the reported consumption is 0,24 kWh/pkm (60,88 g CO2e/pkm if average grid mix is considered)."]
["train, long-distance",1]
["tram",1]
["metro",1]

{"sheet":"Active transport","index":3,"n_rows":49,"n_cols":18,"rows_kept":49,"cut":false,"hidden":false,"merged":[]}
["Bicycle (adult)",null,null,null,"Electric bicycle",null,null,null,"(Electric) cargo bicycle",null,null,null,null,"Bike sharing",null,null,null,"E-scooters - may be implemeted, depending on the data availability"]
[]
["Number of bikes, per household",0,null,null,"Number of e-bikes, per household",0,null,null,"Electric cargo bike?",null,"NO",null,null,"Summary, bike sharing"]
["Months of commuting by a bicycle",0,"months",null,"Months of commuting by an e-bike",0,"months",null,null,null,null,null,null,"Total number of rides, per year",0,"rides"]
["Average length of a commute",3.3,"km",null,"Average length of a commute",3.3,"km",null,"Used or new?",null,"NEW",null,null,"Number of kilometers ridden on a shared bike, per year",{"$f":"O4*P49","v":0},"km"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Total cost, per year",{"$f":"(P11+P12)*IF(O4=0,0,1)","v":0},"€"]
["Summary, bicycle (adult)",null,null,null,"Summary, e-bike",null,null,null,"Summary, cargo bike",null,null,null,null,"Cost, per ride",{"$f":"O6/O4","v":{"$error":"#DIV/0!"}},"€"]
["Total distance ridden on commuter bicycle, per year",{"$f":"21*B4*bike_commute_km*2*bike_number","v":0},"km",null,"Total distance ridden on commuter e-bike, per year",{"$f":"21*F4*ebike_commute_km*2*ebike_number","v":0},"km",null,"Total distance ridden on a (electric) cargo bicycle, per year",0,"km",null,null,"Emissions, per year",{"$f":"P46*O4*IF(O4=0,0,1)","v":0},"kg CO2e"]
["How long do you keep your commuter bike?",15,"years",null,"How long do you keep your commuter e-bike?",15,"years",null,"How long do you keep your cargo bike?",15,"years"]
["Total cost, per year",{"$f":"IF(B4=0,0,B3*((C14-C15)/B9+C16+C17/4+(C18/4)*IF(C20=\"YES\",1,0)+C19/B9))","v":0},"€",null,"Total cost, per year",{"$f":"IF(F4=0,0,F3*((G14-G15)/F9+G16+G17/4+G19/F9+(G27/F9)*IF(G21=\"YES\",1,0)+(G18/4)*IF(G20=\"YES\",1,0)+G33*((G25/G29)*(G30/1000))))","v":0},"€",null,"Total cost, per year",{"$f":"IF(J8=0,0,(K14-K15)/J9+K16+K18/4+K20/J9+(K19/4)*IF(K21=\"YES\",1,0)+(K33*((K25/K29)*(K30/1000)+(K27/J9)*IF(K22=\"YES\",1,0))*IF(K3=\"YES\",1,0)))","v":0},"€"]
["Emissions, per year",{"$f":"IF(B3=0,0,B3*(C46*(1-(C15/C14))/B9))","v":0},"kg CO2e",null,"Emissions, per year",{"$f":"IF(F4=0,0,F3*(G25/G29/1000*G33*(G41+G42)+G37*(1-(G15/G14))/F9+IF(G21=\"YES\",G38*(1-(G15/G14))/F9,0)))","v":0},"kg CO2e",null,"Emissions, per year",{"$f":"IF(J8=0,0,K25/K29/1000+K37*(1-(K15/K14))/J9*K33*(G41+G42)+IF(K22=\"YES\",K38*(1-(K15/K14))/J9,0))","v":0},"kg CO2e",null,null,"Seasonal pass","€",35]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Extra costs (overtime fees)","€",0]
[]
["Purchase price","€",700,null,"Purchase price","€",2500,null,"Purchase price","€",{"$f":"IF(cargo_bike_electric=\"YES\",IF(cargo_bike_type=\"two-wheeler\",5000,4000),IF(cargo_bike_type=\"two-wheeler\",3000,2000))*IF(cargo_bike_new=\"USED\",0.5,1)","v":3000},{"$f":"IF(cargo_bike_electric=\"YES\",IF(cargo_bike_type=\"two-wheeler\",5000,4000),IF(cargo_bike_type=\"two-wheeler\",3000,2000))*IF(cargo_bike_new=\"USED\",0.5,1)","v":3000}]
["Resale value","€",0,null,"Resale value","€",0,null,"Resale value","€",0]
["Annual service costs (yearly basic maintenance)","€",70,null,"Annual service costs (yearly basic maintenance)","€",100,null,"Annual service costs (yearly basic maintenance)","€",150]
["Summer tyres (set of two)","€",50,null,"Summer tyres (set of two)","€",50,null,"Type of cargo bike",null,"two-wheeler"]
["Winter tyres (set of two)","€",100,null,"Winter tyres (set of two)","€",100,null,"Summer tyres (set of two or three)","€",{"$f":"IF(K17=\"two-wheeler\",50,75)","v":50},{"$f":"IF(K17=\"two-wheeler\",50,75)","v":50}]
["Accessories","€",null,null,"Accessories","€",null,null,"Winter tyres (set of two or three)","€",{"$f":"IF(K17=\"two-wheeler\",100,150)","v":100},{"$f":"IF(K17=\"two-wheeler\",100,150)","v":100}]
["Riding in winter?",null,"NO",null,"Riding in winter?",null,"NO",null,"Accessories","€"]
[null,null,null,null,"Buying a new/second battery during the e-bike ownership?",null,"NO",null,"Riding in winter?",null,"NO"]
[null,null,null,null,null,null,null,null,"Buying a new/second battery during the e-bike ownership?",null,"NO"]
[]
["Bicycle (child)",null,null,null,"Battery parameters",null,null,null,"Battery parameters"]
["Number of bikes, per household",0,null,null,"Battery capacity (Wh)","Wh",400,null,"Battery capacity (Wh)","Wh",400]
["Months of commuting by a bicycle",0,"months",null,"Distance per charge","km",40,null,"Distance per charge","km",40]
["Average length of a commute",3.3,"km",null,"Cost of a new battery","€",500,null,"Cost of a new battery","€",500]
[null,null,null,null,"Battery lifetime","charges",300,null,"Battery lifetime","charges",300]
["Summary, bicycle (child)",null,null,null,"Efficiency coefficient of charging",null,0.8,null,"Efficiency coefficient of charging",null,0.8]
["Total distance ridden on commuter bicycle, per year",{"$f":"21*B26*bike_child_commute_km*2*bike_child_number","v":0},"km",null,"Cost of electricity","€/kWh",0.22,null,"Cost of electricity","€/kWh",0.22]
["How long do you keep your commuter bike?",5,"years"]
["Total cost, per year",{"$f":"IF(B26=0,0,B25*((C36-C37)/B31+C38+C39/4+(C40/4)*IF(C42=\"YES\",1,0)+C41/B31))","v":0},"€",null,"Calculated values",null,null,null,"Calculated values"]
["Emissions, per year",{"$f":"IF(B26=0,0,B25*(C46*(1-(C37/C36))/B31))","v":0},"kg CO2e",null,"Number of charges, per year","charges/year",{"$f":"F8/G26","v":0},null,"Number of charges, per year","charges/year",{"$f":"J8/K26","v":0}]
[null,null,null,null,"Battery lifetime","years",{"$f":"G28/G33","v":{"$error":"#DIV/0!"}},null,"Battery lifetime","years",{"$f":"K28/K33","v":{"$error":"#DIV/0!"}}]
[]
["Purchase price","€",300,null,"Emission factors, IPCC 2013 (Source: Ecoinvent v7)",null,null,null,"Emission factors, IPCC 2013 (Source:Zacke (2016), Ecoinvent v7)"]
["Resale value","€",100,null,"e-bike, production","kg CO2e",159,null,"cargo bike, production","kg CO2e",450]
["Annual service costs (yearly basic maintenance)","€",35,null,"battery, Li-ion, rechargeable, prismatic, production","kg CO2e",8.1999999999999993,null,"battery, Li-ion, rechargeable, prismatic, production","kg CO2e",8.1999999999999993]
["Summer tyres (set of two)","€",50]
["Winter tyres (set of two)","€",100,null,"Electricity (Source: Autokalkulaattori)"]
["Accessories","€",null,null,"direct emissions","kg CO2-ekv/kWh",9.6000000000000002E-2]
["Riding in winter?",null,"NO",null,"production emissions","kg CO2-ekv/kWh",1.6E-2]
[]
[]
["Emission factor, IPCC 2013 (Source: Ecoinvent v7)",null,null,null,null,null,null,null,null,null,null,null,null,"emission factor, IPCC 2013 (Source: Ecoinvent v7)"]
["bicycle, production","kg CO2e",141.6,null,null,null,null,null,null,null,null,null,null,"bike sharing, per average ride","kg CO2e",0.61499999999999999]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Average distance of a shared bike trip. Data source: City Bike Finland"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Shared bike trip, 2019-2020 average, Helsinki and Espoo","km",{"$f":"AVERAGE('Ciry Bike Finland - data'!B17:C17)","v":2.220911607142857}]

{"sheet":"Ciry Bike Finland - data","index":4,"n_rows":17,"n_cols":3,"rows_kept":17,"cut":false,"hidden":true,"merged":[]}
["City Bikes Finland"]
["Bike sharing in Helsinki and Espoo (combined data)"]
["Average distance of a single bike sharing trip in 2020, in kilometers"]
[]
["Data source: dev.hsl.fi/citybikes/od-trips-2020/od-trips-2020.zip"]
["Data retrieved 13.11.2020"]
[]
["km",2019,2020]
["March",null,{"$f":"2525.5/1000","v":2.5255000000000001}]
["April",{"$f":"2022/1000","v":2.0219999999999998},{"$f":"2606.5/1000","v":2.6065}]
["May",{"$f":"2083.5/1000","v":2.0834999999999999},{"$f":"2598.8/1000","v":2.5988000000000002}]
["June",{"$f":"2189/1000","v":2.1890000000000001},{"$f":"2462.1/1000","v":2.4621}]
["July",{"$f":"2166.3/1000","v":2.1663000000000001},{"$f":"2288.5/1000","v":2.2885}]
["August",{"$f":"2099.9/1000","v":2.0998999999999999},{"$f":"2333.4/1000","v":2.3334000000000001}]
["September",{"$f":"1944.5/1000","v":1.9444999999999999},{"$f":"2171.2/1000","v":2.1711999999999998}]
["October",{"$f":"1848.2/1000","v":1.8482000000000001},{"$f":"2144.7/1000","v":2.1446999999999998}]
["average trip",{"$f":"AVERAGE(B10:B16)","v":2.0504857142857142},{"$f":"AVERAGE(C9:C16)","v":2.3913375000000001}]